Small Business Cash Flow Projection
Starting date Cash balance alert minimum
0 0 0 0 0 0 0 0 0 0 0 0
Beginning Jan-00
Cash on hand (beginning of month) CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available CASH PAID OUT Advertising Commissions and fees Contract labor Employee benefit programs Insurance (other than health) Interest expense Materials and supplies (in COGS) Meals and entertainment Mortgage interest Office expense Other interest expense Pension and profit-sharing plan Purchases for resale Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Travel Utilities Wages (less emp. credits) Other expenses Other expenses Other expenses Miscellaneous SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month) OTHER OPERATING DATA Sales volume (dollars) Accounts receivable balance Bad debt balance Inventory on hand Accounts payable balance Depreciation 0
Feb-00
0
Mar-00
0
Apr-00
0
May-00
0
Jun-00
0
Jul-00
0
Aug-00
0
Sep-00
0
Oct-00
0
Nov-00
0
Dec-00
0
Total
0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0 0 0 0 0 0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Cash Flow Projection
1
1
1
Cash on Hand
1
1
1
0
0
0
0
0
Period
Cash balance alert minimum
$
-
Projection y Name>
Cash Flow Projection Cash on Hand Minimum Alert